Tabela Panel

Definicja tabeli Panel

Name

Panel

Code

Panel

Comment

Definicja panelu


Lista kolumn tabeli Panel

Name

Code

PanelID

PanelID

PanelTypeID

PanelTypeID

PanelTabID

PanelTabID

SysFctID

SysFctID

ShortName

ShortName

Active

Active

InsertDT

InsertDT

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

HideOrderForm

HideOrderForm

OwnerID

OwnerID

OthersCanEdit

OthersCanEdit


Kolumna PanelID tabeli Panel

Definicja kolumny PanelID tabeli Panel

Name

PanelID

Code

PanelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PanelTypeID tabeli Panel

Definicja kolumny PanelTypeID tabeli Panel

Name

PanelTypeID

Code

PanelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PanelTabID tabeli Panel

Definicja kolumny PanelTabID tabeli Panel

Name

PanelTabID

Code

PanelTabID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SysFctID tabeli Panel

Definicja kolumny SysFctID tabeli Panel

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli Panel

Definicja kolumny ShortName tabeli Panel

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Active tabeli Panel

Definicja kolumny Active tabeli Panel

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertDT tabeli Panel

Definicja kolumny InsertDT tabeli Panel

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertDate tabeli Panel

Definicja kolumny InsertDate tabeli Panel

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna InsertingPerson tabeli Panel

Definicja kolumny InsertingPerson tabeli Panel

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli Panel

Definicja kolumny LastModifiedDT tabeli Panel

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Panel

Definicja kolumny LastModifiedPerson tabeli Panel

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HideOrderForm tabeli Panel

Definicja kolumny HideOrderForm tabeli Panel

Name

HideOrderForm

Code

HideOrderForm

Data Type

NUMBER(5)

Mandatory

No

Comment

Informuje czy uslugi z tego panelu beda zlecane z pominieciem formularza zlecenia


Kolumna OwnerID tabeli Panel

Definicja kolumny OwnerID tabeli Panel

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

No

Comment

pole zawierajaca informacje o osobie która jest wlascicielem panelu ref. do tabeli UserDefinition


Kolumna OthersCanEdit tabeli Panel

Definicja kolumny OthersCanEdit tabeli Panel

Name

OthersCanEdit

Code

OthersCanEdit

Data Type

NUMBER(5)

Mandatory

No

Comment

informacja czy panel moze byc edytowany przez inne osoby niz wlasciciela panelu


Lista kluczy tabeli Panel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Panel

Definicja klucza Identifier_1 tabeli Panel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment